<style type="text/css">
body {
	background-color: #FFA500;
}
body,td,th {
	color: #1C1C1C;
}
</style>

<?php
$con = mysql_connect("localhost","root","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("northwindDB", $con);




$result = mysql_query("SELECT * FROM  nworders " );
echo '<center>' ;
  echo  '<br><h1>Orders</h1><hr><br>';
  echo '<table width="200" border="2">';
  echo '<tr><td bgcolor="#C1CDC1>' . 'OrderID'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'CustomerID'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'EmployeeID'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'OrderDate'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'RequiredDate'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShippedDate'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipVia'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'Freight'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipName'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipAddress'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipCity'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipRegion'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipPostalCode'. '</td>';
  echo '<td bgcolor="#C1CDC1">' . 'ShipCountry'. '</td></tr>';

while($row = mysql_fetch_array($result))
  {
  echo '<tr><td bgcolor="#C1CDC1">' .  $row['OrderID'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['CustomerID'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['EmployeeID'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['OrderDate'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['RequiredDate'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShippedDate'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipVia'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['Freight'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipNamel'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipAddress'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipCity'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipRegion'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipPostalCode'] . '</td>';
  echo '<td bgcolor="#FF4500">' .  $row['ShipCountry'] . '</td></tr>';
  //echo "<br />";

  }
  echo '</table>';
  echo '</center>' ;
mysql_close($con);
?>